package Persistencia;


public class ContratoSqlHelper {
    

    public static String crear(){
return "  insert into ContratodeA (CedulaArrendatario, CodigoInmueble ,CodigoContratodeA ,ValorMensual ,FechadePago ,PermanenciaMinima ) values(?,?,?,?,?,?)   " ;
}
    
    public static String modificar() {
        return "update ContratodeA set ValorMensual=?,FechadePago=?, PermanenciaMinima=? where CodigoContratodeA=?";
    }

     public static String Buscar(String CodigoContratodeA) {
        return "select * from ContratodeA where CodigoContratodeA = "+CodigoContratodeA+"";
    }

    public static String eliminar() {
     return "delete from ContratodeA where CodigoContratodeA= ?";
 } 
    public static String getAllContrato(){
return " SELECT * FROM ContratodeA " ;
}
    
}








